Overview

Brought to you by YData

Dataset statistics

Number of variables	33
Number of observations	10000
Missing cells	780
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	264.0 B

Variable types

Text	3
DateTime	5
Numeric	12
Categorical	13

Alerts

`MaturedIn 10 years` is highly overall correlated with `Policy Code` and 2 other fields	High correlation
`MaturedIn 15 years` is highly overall correlated with `Policy Code` and 1 other fields	High correlation
`MaturedIn 5 years` is highly overall correlated with `Policy Code` and 2 other fields	High correlation
`Maturity Amount` is highly overall correlated with `Total Annual Premium` and 3 other fields	High correlation
`Payment Frequency` is highly overall correlated with `Total Annual Premium` and 2 other fields	High correlation
`Policy Code` is highly overall correlated with `MaturedIn 10 years` and 4 other fields	High correlation
`Policy Type Code` is highly overall correlated with `MaturedIn 10 years` and 3 other fields	High correlation
`Premium Amount` is highly overall correlated with `Total Annual Premium`	High correlation
`Premium Payment Duration` is highly overall correlated with `Purchase Year` and 1 other fields	High correlation
`Purchase Month` is highly overall correlated with `Purchase Quarter`	High correlation
`Purchase Quarter` is highly overall correlated with `Purchase Month`	High correlation
`Purchase Year` is highly overall correlated with `Premium Payment Duration` and 1 other fields	High correlation
`RM ID` is highly overall correlated with `Sales Agent Code` and 2 other fields	High correlation
`Sales Agent Code` is highly overall correlated with `RM ID` and 2 other fields	High correlation
`State` is highly overall correlated with `RM ID` and 2 other fields	High correlation
`Tenure (Years)` is highly overall correlated with `MaturedIn 10 years` and 4 other fields	High correlation
`Total Annual Premium` is highly overall correlated with `Maturity Amount` and 5 other fields	High correlation
`Total Premium Amount` is highly overall correlated with `Maturity Amount` and 4 other fields	High correlation
`Total Premium Payable` is highly overall correlated with `Payment Frequency` and 3 other fields	High correlation
`Total Premium paid` is highly overall correlated with `Maturity Amount` and 6 other fields	High correlation
`Zonal Manager ID` is highly overall correlated with `RM ID` and 2 other fields	High correlation
`profit/gain` is highly overall correlated with `Maturity Amount` and 1 other fields	High correlation
`Policy Status` is highly imbalanced (53.5%)	Imbalance
`Annualized ROI (%)` has 780 (7.8%) missing values	Missing
`Sum Assured INR/Coverage Amount` has unique values	Unique
`Total Premium Amount` has unique values	Unique
`profit/gain` has unique values	Unique
`Premium Payment Duration` has 780 (7.8%) zeros	Zeros
`Total Premium paid` has 780 (7.8%) zeros	Zeros
`Maturity Amount` has 2668 (26.7%) zeros	Zeros

Reproduction

Analysis started	2025-11-08 06:08:25.885480
Analysis finished	2025-11-08 06:09:27.075493
Duration	1 minute and 1.19 second
Software version	ydata-profiling vv4.17.0
Download configuration	config.json

Policy Number
Text

Distinct	9938
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	140000
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9876 ?
Unique (%)	98.8%

Sample

1st row	TRS-POL-892387
2nd row	TRS-POL-603900
3rd row	TRS-POL-336174
4th row	TRS-POL-745853
5th row	TRS-POL-799138

Value	Count	Frequency (%)
trs-pol-794631	2	< 0.1%
trs-pol-382682	2	< 0.1%
trs-pol-462694	2	< 0.1%
trs-pol-314657	2	< 0.1%
trs-pol-833719	2	< 0.1%
trs-pol-347852	2	< 0.1%
trs-pol-299262	2	< 0.1%
trs-pol-248874	2	< 0.1%
trs-pol-147304	2	< 0.1%
trs-pol-728606	2	< 0.1%
Other values (9928)	9980	99.8%

Most occurring characters

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	140000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20000	14.3%
T	10000	7.1%
R	10000	7.1%
S	10000	7.1%
P	10000	7.1%
O	10000	7.1%
L	10000	7.1%
6	6234	4.5%
2	6171	4.4%
7	6131	4.4%
Other values (7)	41464	29.6%

Start Date
Date

Distinct	3237
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2015-07-24 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Last Paid Date
Date

Distinct	1841
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2016-03-28 00:00:00
Maximum	2025-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Tenure (Years)
Real number (ℝ)

High correlation

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.1789

Minimum	10
Maximum	25
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	12
median	20
Q3	20
95-th percentile	25
Maximum	25
Range	15
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.4460867
Coefficient of variation (CV)	0.29958285
Kurtosis	-1.2798103
Mean	18.1789
Median Absolute Deviation (MAD)	5
Skewness	-0.32459948
Sum	181789
Variance	29.659861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
20	4177	41.8%
25	2358	23.6%
10	1818	18.2%
12	1235	12.3%
15	395	4.0%
22	17	0.2%

Value	Count	Frequency (%)
10	1818	18.2%
12	1235	12.3%
15	395	4.0%
20	4177	41.8%
22	17	0.2%
25	2358	23.6%

Value	Count	Frequency (%)
25	2358	23.6%
22	17	0.2%
20	4177	41.8%
15	395	4.0%
12	1235	12.3%
10	1818	18.2%

Date of Purchase
Date

Distinct	3430
Distinct (%)	34.3%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2015-07-24 00:00:00
Maximum	2025-07-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Customer ID
Text

Distinct	9945
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	110000
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9890 ?
Unique (%)	98.9%

Sample

1st row	CUST-189349
2nd row	CUST-802812
3rd row	CUST-541584
4th row	CUST-192788
5th row	CUST-221834

Value	Count	Frequency (%)
cust-788106	2	< 0.1%
cust-293235	2	< 0.1%
cust-527543	2	< 0.1%
cust-716679	2	< 0.1%
cust-869518	2	< 0.1%
cust-670927	2	< 0.1%
cust-384786	2	< 0.1%
cust-584470	2	< 0.1%
cust-867233	2	< 0.1%
cust-906301	2	< 0.1%
Other values (9935)	9980	99.8%

Most occurring characters

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	110000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	10000	9.1%
U	10000	9.1%
S	10000	9.1%
T	10000	9.1%
-	10000	9.1%
4	6185	5.6%
2	6170	5.6%
5	6168	5.6%
9	6168	5.6%
6	6090	5.5%
Other values (5)	29219	26.6%

Sum Assured INR/Coverage Amount
Real number (ℝ)

Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1054222.3

Minimum	100316.82
Maximum	1999546.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	100316.82
5-th percentile	196491.26
Q1	577241.91
median	1059397.7
Q3	1527198.5
95-th percentile	1907294.4
Maximum	1999546.8
Range	1899229.9
Interquartile range (IQR)	949956.59

Descriptive statistics

Standard deviation	549260.89
Coefficient of variation (CV)	0.52101051
Kurtosis	-1.2055452
Mean	1054222.3
Median Absolute Deviation (MAD)	475548.59
Skewness	-0.0035187733
Sum	1.0542223 × 10¹⁰
Variance	3.0168752 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1296266.37	1	< 0.1%
1956818.39	1	< 0.1%
1714308.34	1	< 0.1%
1500822.07	1	< 0.1%
968973.06	1	< 0.1%
1813080.34	1	< 0.1%
1134756.63	1	< 0.1%
1139388.87	1	< 0.1%
1478517.37	1	< 0.1%
1252589.84	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
100316.82	1	< 0.1%
100333.64	1	< 0.1%
100632.55	1	< 0.1%
100665.03	1	< 0.1%
100709.94	1	< 0.1%
100828.11	1	< 0.1%
101628.27	1	< 0.1%
101648.77	1	< 0.1%
102350.25	1	< 0.1%
102430.36	1	< 0.1%

Value	Count	Frequency (%)
1999546.76	1	< 0.1%
1999441.68	1	< 0.1%
1999264.17	1	< 0.1%
1998796.46	1	< 0.1%
1998525.18	1	< 0.1%
1998314.16	1	< 0.1%
1998311.26	1	< 0.1%
1998270.05	1	< 0.1%
1997605.61	1	< 0.1%
1997550.35	1	< 0.1%

Premium Amount
Real number (ℝ)

High correlation

Distinct	9995
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52261.483

Minimum	5028.98
Maximum	99997.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	5028.98
5-th percentile	9641.422
Q1	28251.645
median	52362.055
Q3	76051.84
95-th percentile	95333.279
Maximum	99997.01
Range	94968.03
Interquartile range (IQR)	47800.195

Descriptive statistics

Standard deviation	27511.888
Coefficient of variation (CV)	0.52642762
Kurtosis	-1.2063144
Mean	52261.483
Median Absolute Deviation (MAD)	23881.73
Skewness	0.011607776
Sum	5.2261483 × 10⁸
Variance	7.5690399 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63835.33	2	< 0.1%
58252.59	2	< 0.1%
41203.82	2	< 0.1%
52662.24	2	< 0.1%
20252.27	2	< 0.1%
90879.8	1	< 0.1%
55477.09	1	< 0.1%
41270.19	1	< 0.1%
59448.84	1	< 0.1%
56037.48	1	< 0.1%
Other values (9985)	9985	99.9%

Value	Count	Frequency (%)
5028.98	1	< 0.1%
5055.75	1	< 0.1%
5060.84	1	< 0.1%
5066.79	1	< 0.1%
5082.21	1	< 0.1%
5089.12	1	< 0.1%
5093.81	1	< 0.1%
5096.33	1	< 0.1%
5096.9	1	< 0.1%
5109.71	1	< 0.1%

Value	Count	Frequency (%)
99997.01	1	< 0.1%
99976.71	1	< 0.1%
99974.54	1	< 0.1%
99965.59	1	< 0.1%
99958.74	1	< 0.1%
99944.01	1	< 0.1%
99938.14	1	< 0.1%
99932.81	1	< 0.1%
99925.51	1	< 0.1%
99920.71	1	< 0.1%

Payment Frequency
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Quarterly	3432
Monthly	3324
Annually	3244

Length

Max length	9
Median length	8
Mean length	8.0108
Min length	7

Characters and Unicode

Total characters	80108
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Quarterly
2nd row	Quarterly
3rd row	Quarterly
4th row	Quarterly
5th row	Quarterly

Common Values

Value	Count	Frequency (%)
Quarterly	3432	34.3%
Monthly	3324	33.2%
Annually	3244	32.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
quarterly	3432	34.3%
monthly	3324	33.2%
annually	3244	32.4%

Most occurring characters

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80108	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	13244	16.5%
y	10000	12.5%
n	9812	12.2%
r	6864	8.6%
t	6756	8.4%
a	6676	8.3%
u	6676	8.3%
Q	3432	4.3%
e	3432	4.3%
M	3324	4.1%
Other values (3)	9892	12.3%

Underwriting expenses
Real number (ℝ)

Distinct	9938
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5270.0628

Minimum	500.6
Maximum	9999.78
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	500.6
5-th percentile	971.745
Q1	2853.765
median	5264.165
Q3	7702.4975
95-th percentile	9542.81
Maximum	9999.78
Range	9499.18
Interquartile range (IQR)	4848.7325

Descriptive statistics

Standard deviation	2774.4241
Coefficient of variation (CV)	0.52644991
Kurtosis	-1.2283104
Mean	5270.0628
Median Absolute Deviation (MAD)	2422.77
Skewness	-0.0086640626
Sum	52700628
Variance	7697429.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8312.83	2	< 0.1%
6058.55	2	< 0.1%
9036.62	2	< 0.1%
2861.03	2	< 0.1%
1976.24	2	< 0.1%
6276.62	2	< 0.1%
1654.9	2	< 0.1%
6541.24	2	< 0.1%
6407.7	2	< 0.1%
7090.82	2	< 0.1%
Other values (9928)	9980	99.8%

Value	Count	Frequency (%)
500.6	1	< 0.1%
500.7	1	< 0.1%
501.09	1	< 0.1%
501.27	1	< 0.1%
502.19	1	< 0.1%
502.21	1	< 0.1%
502.29	1	< 0.1%
502.37	1	< 0.1%
503.83	1	< 0.1%
504.06	1	< 0.1%

Value	Count	Frequency (%)
9999.78	1	< 0.1%
9998.66	1	< 0.1%
9998.65	1	< 0.1%
9998.47	1	< 0.1%
9998.31	1	< 0.1%
9997.82	1	< 0.1%
9997.47	1	< 0.1%
9996.08	1	< 0.1%
9994.77	1	< 0.1%
9994.62	1	< 0.1%

Sales Agent Code
Categorical

High correlation

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

AGT-6578	1221
AGT-3567	1120
AGT-3488	1009
AGT-3150	819
AGT-2345	637
Other values (17)	5194

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AGT-6578
2nd row	AGT-6578
3rd row	AGT-6578
4th row	AGT-6578
5th row	AGT-6578

Common Values

Value	Count	Frequency (%)
AGT-6578	1221	12.2%
AGT-3567	1120	11.2%
AGT-3488	1009	10.1%
AGT-3150	819	8.2%
AGT-2345	637	6.4%
AGT-5980	612	6.1%
AGT-3465	550	5.5%
AGT-4456	512	5.1%
AGT-5467	463	4.6%
AGT-7898	458	4.6%
Other values (12)	2599	26.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
agt-6578	1221	12.2%
agt-3567	1120	11.2%
agt-3488	1009	10.1%
agt-3150	819	8.2%
agt-2345	637	6.4%
agt-5980	612	6.1%
agt-3465	550	5.5%
agt-4456	512	5.1%
agt-5467	463	4.6%
agt-7898	458	4.6%
Other values (12)	2599	26.0%

Most occurring characters

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	10000	12.5%
G	10000	12.5%
T	10000	12.5%
-	10000	12.5%
5	7322	9.2%
4	5784	7.2%
8	5703	7.1%
3	4385	5.5%
6	3967	5.0%
9	3687	4.6%
Other values (4)	9152	11.4%

Purchase Month
Categorical

High correlation

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

December	892
March	874
August	866
January	855
July	841
Other values (7)	5672

Length

Max length	9
Median length	7
Mean length	6.165
Min length	3

Characters and Unicode

Total characters	61650
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	April
2nd row	April
3rd row	August
4th row	November
5th row	June

Common Values

Value	Count	Frequency (%)
December	892	8.9%
March	874	8.7%
August	866	8.7%
January	855	8.6%
July	841	8.4%
November	840	8.4%
October	828	8.3%
May	827	8.3%
April	825	8.2%
September	817	8.2%
Other values (2)	1535	15.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
december	892	8.9%
march	874	8.7%
august	866	8.7%
january	855	8.6%
july	841	8.4%
november	840	8.4%
october	828	8.3%
may	827	8.3%
april	825	8.2%
september	817	8.2%
Other values (2)	1535	15.3%

Most occurring characters

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	61650	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	9170	14.9%
r	7423	12.0%
u	4963	8.1%
a	4157	6.7%
b	4123	6.7%
y	3269	5.3%
c	2594	4.2%
m	2549	4.1%
t	2511	4.1%
J	2485	4.0%
Other values (16)	18406	29.9%

Purchase Quarter
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Q4	2560
Q3	2524
Q1	2475
Q2	2441

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	20000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Q2
2nd row	Q2
3rd row	Q3
4th row	Q4
5th row	Q2

Common Values

Value	Count	Frequency (%)
Q4	2560	25.6%
Q3	2524	25.2%
Q1	2475	24.8%
Q2	2441	24.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
q4	2560	25.6%
q3	2524	25.2%
q1	2475	24.8%
q2	2441	24.4%

Most occurring characters

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Q	10000	50.0%
4	2560	12.8%
3	2524	12.6%
1	2475	12.4%
2	2441	12.2%

Purchase Year
Real number (ℝ)

High correlation

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2020.0509

Minimum	2015
Maximum	2025
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	2015
5-th percentile	2016
Q1	2018
median	2020
Q3	2023
95-th percentile	2025
Maximum	2025
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.9134787
Coefficient of variation (CV)	0.0014422798
Kurtosis	-1.1553952
Mean	2020.0509
Median Absolute Deviation (MAD)	2
Skewness	0.004066033
Sum	20200509
Variance	8.488358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
2018	1092	10.9%
2022	1021	10.2%
2024	1019	10.2%
2016	994	9.9%
2019	990	9.9%
2021	983	9.8%
2020	977	9.8%
2023	974	9.7%
2017	953	9.5%
2025	548	5.5%

Value	Count	Frequency (%)
2015	449	4.5%
2016	994	9.9%
2017	953	9.5%
2018	1092	10.9%
2019	990	9.9%
2020	977	9.8%
2021	983	9.8%
2022	1021	10.2%
2023	974	9.7%
2024	1019	10.2%

Value	Count	Frequency (%)
2025	548	5.5%
2024	1019	10.2%
2023	974	9.7%
2022	1021	10.2%
2021	983	9.8%
2020	977	9.8%
2019	990	9.9%
2018	1092	10.9%
2017	953	9.5%
2016	994	9.9%

Policy Anniversary Date
Date

Distinct	3428
Distinct (%)	34.3%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2016-07-24 00:00:00
Maximum	2026-07-23 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Policy Type Code
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

TR-ENDD989	3383
TR-WHCD968	3347
TR-UNCD988	3270

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	100000
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	TR-UNCD988
2nd row	TR-UNCD988
3rd row	TR-UNCD988
4th row	TR-UNCD988
5th row	TR-UNCD988

Common Values

Value	Count	Frequency (%)
TR-ENDD989	3383	33.8%
TR-WHCD968	3347	33.5%
TR-UNCD988	3270	32.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
tr-endd989	3383	33.8%
tr-whcd968	3347	33.5%
tr-uncd988	3270	32.7%

Most occurring characters

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	100000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	13383	13.4%
9	13383	13.4%
8	13270	13.3%
R	10000	10.0%
T	10000	10.0%
-	10000	10.0%
N	6653	6.7%
C	6617	6.6%
E	3383	3.4%
W	3347	3.3%
Other values (3)	9964	10.0%

Policy Code
Categorical

High correlation

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

UGP-TRCD-9834	3205
JSU-TRCD-9813	2358
LGA-TRCD-9829	1818
STP-TRCD-9812	1236
ICP-TRCD-9832	972
Other values (3)	411

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	130000
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UGP-TRCD-9834
2nd row	UGP-TRCD-9834
3rd row	UGP-TRCD-9834
4th row	UGP-TRCD-9834
5th row	UGP-TRCD-9834

Common Values

Value	Count	Frequency (%)
UGP-TRCD-9834	3205	32.0%
JSU-TRCD-9813	2358	23.6%
LGA-TRCD-9829	1818	18.2%
STP-TRCD-9812	1236	12.4%
ICP-TRCD-9832	972	9.7%
WLS-TRCD-9814	329	3.3%
RSE-TRCD-9856	65	0.7%
GWB-TRCD-9833	17	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ugp-trcd-9834	3205	32.0%
jsu-trcd-9813	2358	23.6%
lga-trcd-9829	1818	18.2%
stp-trcd-9812	1236	12.4%
icp-trcd-9832	972	9.7%
wls-trcd-9814	329	3.3%
rse-trcd-9856	65	0.7%
gwb-trcd-9833	17	0.2%

Most occurring characters

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	130000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	20000	15.4%
9	11818	9.1%
T	11236	8.6%
C	10972	8.4%
R	10065	7.7%
D	10000	7.7%
8	10000	7.7%
3	6569	5.1%
U	5563	4.3%
P	5413	4.2%
Other values (14)	28364	21.8%

Policy Status
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Active	7332
Surrendered	2524
Lapsed	107
Claimed	37

Length

Max length	11
Median length	6
Mean length	7.2657
Min length	6

Characters and Unicode

Total characters	72657
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	7332	73.3%
Surrendered	2524	25.2%
Lapsed	107	1.1%
Claimed	37	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
active	7332	73.3%
surrendered	2524	25.2%
lapsed	107	1.1%
claimed	37	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	72657	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	15048	20.7%
r	7572	10.4%
i	7369	10.1%
A	7332	10.1%
c	7332	10.1%
t	7332	10.1%
v	7332	10.1%
d	5192	7.1%
u	2524	3.5%
S	2524	3.5%
Other values (8)	3100	4.3%

State
Categorical

High correlation

Distinct	22
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Delhi	1221
Uttar Pradesh	1120
Sikkim	1009
Haryana	819
Madhya Pradesh	637
Other values (17)	5194

Length

Max length	16
Median length	13
Mean length	8.8023
Min length	3

Characters and Unicode

Total characters	88023
Distinct characters	35
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Delhi
2nd row	Delhi
3rd row	Delhi
4th row	Delhi
5th row	Delhi

Common Values

Value	Count	Frequency (%)
Delhi	1221	12.2%
Uttar Pradesh	1120	11.2%
Sikkim	1009	10.1%
Haryana	819	8.2%
Madhya Pradesh	637	6.4%
Tamilnadu	612	6.1%
Rajasthan	550	5.5%
Bihar	512	5.1%
Chandigarh	463	4.6%
Uttarakhand	458	4.6%
Other values (12)	2599	26.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pradesh	2301	18.5%
delhi	1221	9.8%
uttar	1120	9.0%
sikkim	1009	8.1%
haryana	819	6.6%
madhya	637	5.1%
tamilnadu	612	4.9%
rajasthan	550	4.4%
bihar	512	4.1%
chandigarh	463	3.7%
Other values (14)	3209	25.8%

Most occurring characters

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	88023	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	17899	20.3%
h	8562	9.7%
r	7840	8.9%
d	5240	6.0%
i	5236	5.9%
e	4402	5.0%
t	4319	4.9%
n	4169	4.7%
s	3949	4.5%
k	2992	3.4%
Other values (25)	23415	26.6%

RM ID
Categorical

High correlation

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

RMN7A3X1	3799
RMC9F7L5	2018
RMS4B9K2	1661
RME2D5Q4	1509
RMW8C6P3	1013

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RMN7A3X1
2nd row	RMN7A3X1
3rd row	RMN7A3X1
4th row	RMN7A3X1
5th row	RMN7A3X1

Common Values

Value	Count	Frequency (%)
RMN7A3X1	3799	38.0%
RMC9F7L5	2018	20.2%
RMS4B9K2	1661	16.6%
RME2D5Q4	1509	15.1%
RMW8C6P3	1013	10.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rmn7a3x1	3799	38.0%
rmc9f7l5	2018	20.2%
rms4b9k2	1661	16.6%
rme2d5q4	1509	15.1%
rmw8c6p3	1013	10.1%

Most occurring characters

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
R	10000	12.5%
M	10000	12.5%
7	5817	7.3%
3	4812	6.0%
N	3799	4.7%
A	3799	4.7%
X	3799	4.7%
1	3799	4.7%
9	3679	4.6%
5	3527	4.4%
Other values (15)	26969	33.7%

Zonal Manager ID
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

ZMN8K2L1	5817
ZMW3T7P8	2522
ZMS5Q4R2	1661

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	80000
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ZMN8K2L1
2nd row	ZMN8K2L1
3rd row	ZMN8K2L1
4th row	ZMN8K2L1
5th row	ZMN8K2L1

Common Values

Value	Count	Frequency (%)
ZMN8K2L1	5817	58.2%
ZMW3T7P8	2522	25.2%
ZMS5Q4R2	1661	16.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
zmn8k2l1	5817	58.2%
zmw3t7p8	2522	25.2%
zms5q4r2	1661	16.6%

Most occurring characters

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	80000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
Z	10000	12.5%
M	10000	12.5%
8	8339	10.4%
2	7478	9.3%
N	5817	7.3%
K	5817	7.3%
L	5817	7.3%
1	5817	7.3%
W	2522	3.2%
3	2522	3.2%
Other values (8)	15871	19.8%

Total Annual Premium
Real number (ℝ)

High correlation

Distinct	9999
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	296301.64

Minimum	5028.98
Maximum	1199964.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	5028.98
5-th percentile	20035.538
Q1	65387.482
median	175249.96
Q3	381875.01
95-th percentile	1029702.6
Maximum	1199964.1
Range	1194935.1
Interquartile range (IQR)	316487.53

Descriptive statistics

Standard deviation	314418.55
Coefficient of variation (CV)	1.0611435
Kurtosis	0.79217685
Mean	296301.64
Median Absolute Deviation (MAD)	130309.79
Skewness	1.3603017
Sum	2.9630164 × 10⁹
Variance	9.8859025 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
255341.32	2	< 0.1%
24301.8	1	< 0.1%
237795.36	1	< 0.1%
672449.76	1	< 0.1%
80158.84	1	< 0.1%
346829.16	1	< 0.1%
168341.88	1	< 0.1%
98376.36	1	< 0.1%
306750.08	1	< 0.1%
75307	1	< 0.1%
Other values (9989)	9989	99.9%

Value	Count	Frequency (%)
5028.98	1	< 0.1%
5093.81	1	< 0.1%
5096.33	1	< 0.1%
5170.37	1	< 0.1%
5172.51	1	< 0.1%
5173.39	1	< 0.1%
5180.41	1	< 0.1%
5206.56	1	< 0.1%
5234.17	1	< 0.1%
5258.39	1	< 0.1%

Value	Count	Frequency (%)
1199964.12	1	< 0.1%
1199720.52	1	< 0.1%
1199587.08	1	< 0.1%
1199257.68	1	< 0.1%
1199193.72	1	< 0.1%
1198971.24	1	< 0.1%
1198892.52	1	< 0.1%
1198877.04	1	< 0.1%
1198677	1	< 0.1%
1198274.4	1	< 0.1%

Total Premium Amount
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5354518.2

Minimum	50289.8
Maximum	29993013
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	50289.8
5-th percentile	305977.84
Q1	1082487.5
median	2817877.2
Q3	7257986.1
95-th percentile	20050961
Maximum	29993013
Range	29942723
Interquartile range (IQR)	6175498.6

Descriptive statistics

Standard deviation	6133014.4
Coefficient of variation (CV)	1.1453905
Kurtosis	2.6149785
Mean	5354518.2
Median Absolute Deviation (MAD)	2154496.9
Skewness	1.7471532
Sum	5.3545182 × 10¹⁰
Variance	3.7613865 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10086746.4	1	< 0.1%
8360972.64	1	< 0.1%
570386.64	1	< 0.1%
1998433.8	1	< 0.1%
1235886	1	< 0.1%
13221302.4	1	< 0.1%
2897236.8	1	< 0.1%
1852450.8	1	< 0.1%
286908.48	1	< 0.1%
7224864.24	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
50289.8	1	< 0.1%
51733.9	1	< 0.1%
52065.6	1	< 0.1%
53070.3	1	< 0.1%
53676.5	1	< 0.1%
58897	1	< 0.1%
60457.6	1	< 0.1%
61013.6	1	< 0.1%
62810.04	1	< 0.1%
63273.96	1	< 0.1%

Value	Count	Frequency (%)
29993013	1	< 0.1%
29989677	1	< 0.1%
29981442	1	< 0.1%
29974281	1	< 0.1%
29966925	1	< 0.1%
29956860	1	< 0.1%
29949351	1	< 0.1%
29940159	1	< 0.1%
29917530	1	< 0.1%
29917218	1	< 0.1%

Premium Payment Duration
Real number (ℝ)

High correlation Zeros

Distinct	11
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1219

Minimum	0
Maximum	10
Zeros	780
Zeros (%)	7.8%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	3
Q3	7
95-th percentile	9
Maximum	10
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8913451
Coefficient of variation (CV)	0.7014593
Kurtosis	-1.0120868
Mean	4.1219
Median Absolute Deviation (MAD)	2
Skewness	0.41546815
Sum	41219
Variance	8.3598764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
3	1560	15.6%
2	1530	15.3%
1	1339	13.4%
7	811	8.1%
0	780	7.8%
5	752	7.5%
6	749	7.5%
4	740	7.4%
8	714	7.1%
9	713	7.1%

Value	Count	Frequency (%)
0	780	7.8%
1	1339	13.4%
2	1530	15.3%
3	1560	15.6%
4	740	7.4%
5	752	7.5%
6	749	7.5%
7	811	8.1%
8	714	7.1%
9	713	7.1%

Value	Count	Frequency (%)
10	312	3.1%
9	713	7.1%
8	714	7.1%
7	811	8.1%
6	749	7.5%
5	752	7.5%
4	740	7.4%
3	1560	15.6%
2	1530	15.3%
1	1339	13.4%

Total Premium paid
Real number (ℝ)

High correlation Zeros

Distinct	9221
Distinct (%)	92.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1226279.8

Minimum	0
Maximum	11960249
Zeros	780
Zeros (%)	7.8%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	152425.55
median	501077.43
Q3	1538262.9
95-th percentile	5402427.5
Maximum	11960249
Range	11960249
Interquartile range (IQR)	1385837.3

Descriptive statistics

Standard deviation	1805280.1
Coefficient of variation (CV)	1.4721601
Kurtosis	7.1127732
Mean	1226279.8
Median Absolute Deviation (MAD)	430973.93
Skewness	2.545756
Sum	1.2262798 × 10¹⁰
Variance	3.2590362 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	780	7.8%
3353775.12	1	< 0.1%
303767.52	1	< 0.1%
188071.53	1	< 0.1%
505025.64	1	< 0.1%
37201.32	1	< 0.1%
45901.74	1	< 0.1%
425432.16	1	< 0.1%
287158.32	1	< 0.1%
2113335.36	1	< 0.1%
Other values (9211)	9211	92.1%

Value	Count	Frequency (%)
0	780	7.8%
5180.41	1	< 0.1%
5206.56	1	< 0.1%
5234.17	1	< 0.1%
5272.83	1	< 0.1%
5367.65	1	< 0.1%
5560.24	1	< 0.1%
6084.13	1	< 0.1%
6444.47	1	< 0.1%
6649.68	1	< 0.1%

Value	Count	Frequency (%)
11960248.8	1	< 0.1%
11946362.4	1	< 0.1%
11777304	1	< 0.1%
11583998.4	1	< 0.1%
11460394.8	1	< 0.1%
11294230.8	1	< 0.1%
11179504.8	1	< 0.1%
10898515.2	1	< 0.1%
10778457.24	1	< 0.1%
10770740.4	1	< 0.1%

Total Premium Payable
Real number (ℝ)

High correlation

Distinct	9940
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4128238.4

Minimum	0
Maximum	29608197
Zeros	61
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	163144.38
Q1	749094.76
median	1950218.6
Q3	5547364.8
95-th percentile	15934677
Maximum	29608197
Range	29608197
Interquartile range (IQR)	4798270.1

Descriptive statistics

Standard deviation	5086430.9
Coefficient of variation (CV)	1.2321069
Kurtosis	3.8062448
Mean	4128238.4
Median Absolute Deviation (MAD)	1555287.4
Skewness	1.9681932
Sum	4.1282384 × 10¹⁰
Variance	2.587178 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	61	0.6%
1271362.56	1	< 0.1%
2853544.32	1	< 0.1%
3362248.8	1	< 0.1%
4294501.12	1	< 0.1%
6141933.6	1	< 0.1%
698564.57	1	< 0.1%
1164427.68	1	< 0.1%
9959739.84	1	< 0.1%
577809.48	1	< 0.1%
Other values (9930)	9930	99.3%

Value	Count	Frequency (%)
0	61	0.6%
7807.85	1	< 0.1%
8305.8	1	< 0.1%
10346.78	1	< 0.1%
11712.78	1	< 0.1%
16257.14	1	< 0.1%
17198.88	1	< 0.1%
17338.68	1	< 0.1%
19383.3	1	< 0.1%
19432.98	1	< 0.1%

Value	Count	Frequency (%)
29608197	1	< 0.1%
28875321	1	< 0.1%
28768248	1	< 0.1%
28695093	1	< 0.1%
28538049.6	1	< 0.1%
28469756.16	1	< 0.1%
27880914.24	1	< 0.1%
27806673.6	1	< 0.1%
27785122.56	1	< 0.1%
27672789	1	< 0.1%

Maturity Amount
Real number (ℝ)

High correlation Zeros

Distinct	7333
Distinct (%)	73.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4332541.2

Minimum	0
Maximum	34488129
Zeros	2668
Zeros (%)	26.7%
Negative	0
Negative (%)	0.0%
Memory size	78.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1521059.6
Q3	5876414.8
95-th percentile	19904692
Maximum	34488129
Range	34488129
Interquartile range (IQR)	5876414.8

Descriptive statistics

Standard deviation	6462753.7
Coefficient of variation (CV)	1.4916774
Kurtosis	4.5457543
Mean	4332541.2
Median Absolute Deviation (MAD)	1521059.6
Skewness	2.1504481
Sum	4.3325412 × 10¹⁰
Variance	4.1767186 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2668	26.7%
896638.58	1	< 0.1%
3686687.172	1	< 0.1%
2154442.284	1	< 0.1%
6717826.752	1	< 0.1%
2441177.136	1	< 0.1%
2467091.94	1	< 0.1%
3312469.608	1	< 0.1%
4339682.1	1	< 0.1%
4814870.052	1	< 0.1%
Other values (7323)	7323	73.2%

Value	Count	Frequency (%)
0	2668	26.7%
52301.392	1	< 0.1%
53803.256	1	< 0.1%
54148.224	1	< 0.1%
55193.112	1	< 0.1%
61252.88	1	< 0.1%
62875.904	1	< 0.1%
63454.144	1	< 0.1%
65636.4918	1	< 0.1%
66121.2882	1	< 0.1%

Value	Count	Frequency (%)
34488128.55	1	< 0.1%
34478658.3	1	< 0.1%
34470423.15	1	< 0.1%
34450389	1	< 0.1%
34441753.65	1	< 0.1%
34431182.85	1	< 0.1%
34405159.5	1	< 0.1%
34326102.75	1	< 0.1%
34291892.55	1	< 0.1%
34186205.25	1	< 0.1%

Annualized ROI (%)
Text

Missing

Distinct	149
Distinct (%)	1.6%
Missing	780
Missing (%)	7.8%
Memory size	78.3 KiB

Length

Max length	8
Median length	5
Mean length	5.9921909
Min length	5

Characters and Unicode

Total characters	55248
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	0.1%

Sample

1st row	10.45%
2nd row	6.69%
3rd row	6.69%
4th row	4.45%
5th row	5.16%

Value	Count	Frequency (%)
100.00	2307	25.0%
7.66	223	2.4%
12.71	221	2.4%
10.45	221	2.4%
5.87	213	2.3%
4.55	205	2.2%
5.16	202	2.2%
6.69	201	2.2%
8.87	196	2.1%
16.69	173	1.9%
Other values (139)	5058	54.9%

Most occurring characters

Value	Count	Frequency (%)
0	10991	19.9%
%	9220	16.7%
.	9220	16.7%
1	6095	11.0%
6	3132	5.7%
5	2876	5.2%
7	2550	4.6%
4	2537	4.6%
-	2307	4.2%
8	1973	3.6%
Other values (3)	4347	7.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	55248	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	10991	19.9%
%	9220	16.7%
.	9220	16.7%
1	6095	11.0%
6	3132	5.7%
5	2876	5.2%
7	2550	4.6%
4	2537	4.6%
-	2307	4.2%
8	1973	3.6%
Other values (3)	4347	7.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	55248	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	10991	19.9%
%	9220	16.7%
.	9220	16.7%
1	6095	11.0%
6	3132	5.7%
5	2876	5.2%
7	2550	4.6%
4	2537	4.6%
-	2307	4.2%
8	1973	3.6%
Other values (3)	4347	7.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	55248	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	10991	19.9%
%	9220	16.7%
.	9220	16.7%
1	6095	11.0%
6	3132	5.7%
5	2876	5.2%
7	2550	4.6%
4	2537	4.6%
-	2307	4.2%
8	1973	3.6%
Other values (3)	4347	7.9%

profit/gain
Real number (ℝ)

High correlation Unique

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1021976.9

Minimum	-29993013
Maximum	4498451.5
Zeros	0
Zeros (%)	0.0%
Negative	2668
Negative (%)	26.7%
Memory size	78.3 KiB

Quantile statistics

Minimum	-29993013
5-th percentile	-9313602.8
Q1	-409882.61
median	111307.38
Q3	527153.29
95-th percentile	1910616.8
Maximum	4498451.5
Range	34491465
Interquartile range (IQR)	937035.9

Descriptive statistics

Standard deviation	4163831.9
Coefficient of variation (CV)	-4.0742915
Kurtosis	14.195781
Mean	-1021976.9
Median Absolute Deviation (MAD)	428687.35
Skewness	-3.4807872
Sum	-1.0219769 × 10¹⁰
Variance	1.7337496 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-10086746.4	1	< 0.1%
-8360972.64	1	< 0.1%
-570386.64	1	< 0.1%
-1998433.8	1	< 0.1%
-1235886	1	< 0.1%
-13221302.4	1	< 0.1%
-2897236.8	1	< 0.1%
-1852450.8	1	< 0.1%
-286908.48	1	< 0.1%
-7224864.24	1	< 0.1%
Other values (9990)	9990	99.9%

Value	Count	Frequency (%)
-29993013	1	< 0.1%
-29966925	1	< 0.1%
-29917218	1	< 0.1%
-29804361	1	< 0.1%
-29803695	1	< 0.1%
-29681673	1	< 0.1%
-29608197	1	< 0.1%
-29535825	1	< 0.1%
-29458872	1	< 0.1%
-29042619	1	< 0.1%

Value	Count	Frequency (%)
4498451.55	1	< 0.1%
4497216.3	1	< 0.1%
4496142.15	1	< 0.1%
4493529	1	< 0.1%
4492402.65	1	< 0.1%
4491023.85	1	< 0.1%
4487629.5	1	< 0.1%
4477317.75	1	< 0.1%
4472855.55	1	< 0.1%
4459070.25	1	< 0.1%

Tenure Date
Date

Distinct	5538
Distinct (%)	55.4%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

Minimum	2025-01-08 00:00:00
Maximum	2049-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

MaturedIn 5 years
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

0	8554
1	1446

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

Most occurring characters

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	8554	85.5%
1	1446	14.5%

MaturedIn 10 years
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

0	7871
1	2129

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

Most occurring characters

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	7871	78.7%
1	2129	21.3%

MaturedIn 15 years
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.3 KiB

0	7068
1	2932

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	10000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Most occurring characters

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	7068	70.7%
1	2932	29.3%

Interactions

Correlations

	MaturedIn 10 years	MaturedIn 15 years	MaturedIn 5 years	Maturity Amount	Payment Frequency	Policy Code	Policy Status	Policy Type Code	Premium Amount	Premium Payment Duration	Purchase Month	Purchase Quarter	Purchase Year	RM ID	Sales Agent Code	State	Sum Assured INR/Coverage Amount	Tenure (Years)	Total Annual Premium	Total Premium Amount	Total Premium Payable	Total Premium paid	Underwriting expenses	Zonal Manager ID	profit/gain
MaturedIn 10 years	1.000	0.151	0.021	0.131	0.011	0.624	0.036	0.613	0.019	0.233	0.018	0.023	0.202	0.028	0.051	0.051	0.000	0.624	0.003	0.158	0.163	0.047	0.024	0.016	0.172
MaturedIn 15 years	0.151	1.000	0.264	0.085	0.000	0.527	0.035	0.374	0.000	0.308	0.024	0.029	0.378	0.087	0.174	0.174	0.000	0.527	0.000	0.109	0.134	0.098	0.010	0.088	0.038
MaturedIn 5 years	0.021	0.264	1.000	0.129	0.013	0.628	0.000	0.572	0.000	0.328	0.061	0.056	0.394	0.016	0.000	0.000	0.000	0.628	0.000	0.161	0.234	0.151	0.000	0.000	0.164
Maturity Amount	0.131	0.085	0.129	1.000	0.483	0.113	0.252	0.178	0.278	0.364	0.000	0.012	-0.007	0.010	0.032	0.032	-0.012	0.135	0.510	0.532	0.437	0.586	0.004	0.019	0.988
Payment Frequency	0.011	0.000	0.013	0.483	1.000	0.013	0.007	0.010	0.000	0.000	0.022	0.020	0.000	0.009	0.026	0.026	0.019	0.000	0.721	0.622	0.544	0.426	0.000	0.004	0.438
Policy Code	0.624	0.527	0.628	0.113	0.013	1.000	0.123	1.000	0.010	0.012	0.000	0.005	0.000	0.163	0.232	0.232	0.000	1.000	0.013	0.135	0.124	0.001	0.024	0.217	0.125
Policy Status	0.036	0.035	0.000	0.252	0.007	0.123	1.000	0.000	0.005	0.319	0.000	0.000	0.000	0.138	0.298	0.298	0.010	0.086	0.003	0.000	0.047	0.125	0.007	0.072	0.404
Policy Type Code	0.613	0.374	0.572	0.178	0.010	1.000	0.000	1.000	0.007	0.000	0.000	0.011	0.005	0.004	0.036	0.036	0.000	0.871	0.011	0.211	0.213	0.000	0.000	0.004	0.205
Premium Amount	0.019	0.000	0.000	0.278	0.000	0.010	0.005	0.007	1.000	0.010	0.009	0.003	-0.015	0.015	0.006	0.006	-0.007	-0.009	0.526	0.499	0.463	0.387	0.008	0.023	0.236
Premium Payment Duration	0.233	0.308	0.328	0.364	0.000	0.012	0.319	0.000	0.010	1.000	0.073	0.120	-0.827	0.023	0.033	0.033	-0.009	0.018	0.004	0.008	-0.190	0.596	0.015	0.016	0.359
Purchase Month	0.018	0.024	0.061	0.000	0.022	0.000	0.000	0.000	0.009	0.073	1.000	1.000	0.082	0.009	0.000	0.000	0.017	0.006	0.013	0.009	0.012	0.019	0.015	0.013	0.003
Purchase Quarter	0.023	0.029	0.056	0.012	0.020	0.005	0.000	0.011	0.003	0.120	1.000	1.000	0.133	0.012	0.000	0.000	0.022	0.007	0.005	0.017	0.005	0.028	0.008	0.006	0.000
Purchase Year	0.202	0.378	0.394	-0.007	0.000	0.000	0.000	0.005	-0.015	-0.827	0.082	0.133	1.000	0.009	0.005	0.005	0.010	-0.009	-0.015	-0.016	0.150	-0.507	-0.016	0.000	-0.006
RM ID	0.028	0.087	0.016	0.010	0.009	0.163	0.138	0.004	0.015	0.023	0.009	0.012	0.009	1.000	0.999	0.999	0.000	0.108	0.009	0.017	0.000	0.000	0.000	1.000	0.021
Sales Agent Code	0.051	0.174	0.000	0.032	0.026	0.232	0.298	0.036	0.006	0.033	0.000	0.000	0.005	0.999	1.000	1.000	0.000	0.183	0.013	0.029	0.023	0.000	0.005	0.999	0.041
State	0.051	0.174	0.000	0.032	0.026	0.232	0.298	0.036	0.006	0.033	0.000	0.000	0.005	0.999	1.000	1.000	0.000	0.183	0.013	0.029	0.023	0.000	0.005	0.999	0.041
Sum Assured INR/Coverage Amount	0.000	0.000	0.000	-0.012	0.019	0.000	0.010	0.000	-0.007	-0.009	0.017	0.022	0.010	0.000	0.000	0.000	1.000	-0.007	-0.014	-0.015	-0.012	-0.019	-0.009	0.000	-0.012
Tenure (Years)	0.624	0.527	0.628	0.135	0.000	1.000	0.086	0.871	-0.009	0.018	0.006	0.007	-0.009	0.108	0.183	0.183	-0.007	1.000	-0.023	0.225	0.327	0.001	0.009	0.145	0.159
Total Annual Premium	0.003	0.000	0.000	0.510	0.721	0.013	0.003	0.011	0.526	0.004	0.013	0.005	-0.015	0.009	0.013	0.013	-0.014	-0.023	1.000	0.963	0.888	0.736	0.002	0.010	0.423
Total Premium Amount	0.158	0.109	0.161	0.532	0.622	0.135	0.000	0.211	0.499	0.008	0.009	0.017	-0.016	0.017	0.029	0.029	-0.015	0.225	0.963	1.000	0.955	0.715	0.004	0.020	0.452
Total Premium Payable	0.163	0.134	0.234	0.437	0.544	0.124	0.047	0.213	0.463	-0.190	0.012	0.005	0.150	0.000	0.023	0.023	-0.012	0.327	0.888	0.955	1.000	0.544	-0.000	0.000	0.367
Total Premium paid	0.047	0.098	0.151	0.586	0.426	0.001	0.125	0.000	0.387	0.596	0.019	0.028	-0.507	0.000	0.000	0.000	-0.019	0.001	0.736	0.715	0.544	1.000	0.006	0.000	0.523
Underwriting expenses	0.024	0.010	0.000	0.004	0.000	0.024	0.007	0.000	0.008	0.015	0.015	0.008	-0.016	0.000	0.005	0.005	-0.009	0.009	0.002	0.004	-0.000	0.006	1.000	0.005	0.004
Zonal Manager ID	0.016	0.088	0.000	0.019	0.004	0.217	0.072	0.004	0.023	0.016	0.013	0.006	0.000	1.000	0.999	0.999	0.000	0.145	0.010	0.020	0.000	0.000	0.005	1.000	0.033
profit/gain	0.172	0.038	0.164	0.988	0.438	0.125	0.404	0.205	0.236	0.359	0.003	0.000	-0.006	0.021	0.041	0.041	-0.012	0.159	0.423	0.452	0.367	0.523	0.004	0.033	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	Policy Number	Start Date	Last Paid Date	Tenure (Years)	Date of Purchase	Customer ID	Sum Assured INR/Coverage Amount	Premium Amount	Payment Frequency	Underwriting expenses	Sales Agent Code	Purchase Month	Purchase Quarter	Purchase Year	Policy Anniversary Date	Policy Type Code	Policy Code	Policy Status	State	RM ID	Zonal Manager ID	Total Annual Premium	Total Premium Amount	Premium Payment Duration	Total Premium paid	Total Premium Payable	Maturity Amount	Annualized ROI (%)	profit/gain	Tenure Date	MaturedIn 15 years
0	TRS-POL-892387	18 April 2022	18 April 2025	20	18 April 2022	CUST-189349	619301.17	42085.47	Quarterly	3335.88	AGT-6578	April	Q2	2022	18 April 2023	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	168341.88	3366837.6	3	505025.64	2861811.96	3686687.172	10.45%	319849.572	18-04-2042	0
1	TRS-POL-603900	19 April 2019	19 April 2025	20	19 April 2019	CUST-802812	1330929.44	24594.09	Quarterly	7587.61	AGT-6578	April	Q2	2019	19 April 2020	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	98376.36	1967527.2	6	590258.16	1377269.04	2154442.284	6.69%	186915.084	19-04-2039	1
2	TRS-POL-336174	12 August 2019	12 August 2025	20	12 August 2019	CUST-541584	714993.62	76687.52	Quarterly	4288.23	AGT-6578	August	Q3	2019	12 August 2020	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	306750.08	6135001.6	6	1840500.48	4294501.12	6717826.752	6.69%	582825.152	12-08-2039	1
3	TRS-POL-745853	14 November 2016	14 November 2025	20	14 November 2016	CUST-192788	270848.26	18826.75	Quarterly	6725.00	AGT-6578	November	Q4	2016	14 November 2017	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	75307.00	1506140.0	9	677763.00	828377.00	1619100.500	4.45%	112960.500	14-11-2036	1
4	TRS-POL-799138	09 June 2017	09 June 2025	20	09 June 2017	CUST-221834	1885143.74	93979.29	Quarterly	5369.76	AGT-6578	June	Q2	2017	09 June 2018	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	375917.16	7518343.2	8	3007337.28	4511005.92	8232585.804	5.16%	714242.604	09-06-2037	1
5	TRS-POL-161147	08 March 2024	08 March 2024	20	20 April 2025	CUST-114960	954941.34	10426.03	Quarterly	5087.14	AGT-6578	April	Q2	2025	20 April 2026	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	41704.12	834082.4	0	0.00	834082.40	896638.580	NaN	62556.180	08-03-2044	0
6	TRS-POL-765871	12 May 2021	12 May 2025	20	12 May 2021	CUST-360696	1765342.50	28163.15	Quarterly	825.98	AGT-6578	May	Q2	2021	12 May 2022	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	112652.60	2253052.0	4	450610.40	1802441.60	2467091.940	8.87%	214039.940	12-05-2041	0
7	TRS-POL-746555	15 February 2021	15 February 2025	20	15 February 2021	CUST-876796	503342.80	37813.58	Quarterly	6045.14	AGT-6578	February	Q1	2021	15 February 2022	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	151254.32	3025086.4	4	605017.28	2420069.12	3312469.608	8.87%	287383.208	15-02-2041	0
8	TRS-POL-110143	31 July 2020	31 July 2025	20	31 July 2020	CUST-416715	1994578.66	49539.75	Quarterly	3456.37	AGT-6578	July	Q3	2020	31 July 2021	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	198159.00	3963180.0	5	990795.00	2972385.00	4339682.100	7.66%	376502.100	31-07-2040	1
9	TRS-POL-742236	25 May 2017	25 May 2025	20	25 May 2017	CUST-964599	1170360.87	54964.27	Quarterly	2759.54	AGT-6578	May	Q2	2017	25 May 2018	TR-UNCD988	UGP-TRCD-9834	Active	Delhi	RMN7A3X1	ZMN8K2L1	219857.08	4397141.6	8	1758856.64	2638284.96	4814870.052	5.16%	417728.452	25-05-2037	1

	Policy Number	Start Date	Last Paid Date	Tenure (Years)	Date of Purchase	Customer ID	Sum Assured INR/Coverage Amount	Premium Amount	Payment Frequency	Underwriting expenses	Sales Agent Code	Purchase Month	Purchase Quarter	Purchase Year	Policy Anniversary Date	Policy Type Code	Policy Code	Policy Status	State	RM ID	Zonal Manager ID	Total Annual Premium	Total Premium Amount	Premium Payment Duration	Total Premium paid	Total Premium Payable	Annualized ROI (%)	profit/gain	Tenure Date	MaturedIn 5 years	MaturedIn 10 years	MaturedIn 15 years
9990	TRS-POL-913836	28 August 2021	28 August 2021	12	28 August 2021	CUST-399205	606829.65	11862.97	Quarterly	5943.52	AGT-4456	August	Q3	2021	28 August 2022	TR-ENDD989	STP-TRCD-9812	Lapsed	Bihar	RMC9F7L5	ZMN8K2L1	47451.88	569422.56	0	0.00	569422.56	NaN	-569422.56	28-08-2033	0	1	0
9991	TRS-POL-752455	28 March 2016	28 March 2016	12	28 March 2016	CUST-639678	604946.71	73364.96	Annually	6338.24	AGT-4456	March	Q1	2016	28 March 2017	TR-ENDD989	STP-TRCD-9812	Claimed	Bihar	RMC9F7L5	ZMN8K2L1	73364.96	880379.52	0	0.00	880379.52	NaN	-880379.52	28-03-2028	1	0	0
9992	TRS-POL-981638	10 June 2016	10 June 2016	12	10 June 2016	CUST-248477	1543871.18	39037.94	Monthly	4564.53	AGT-4456	June	Q2	2016	10 June 2017	TR-ENDD989	STP-TRCD-9812	Claimed	Bihar	RMC9F7L5	ZMN8K2L1	468455.28	5621463.36	0	0.00	5621463.36	NaN	-5621463.36	10-06-2028	1	0	0
9993	TRS-POL-655995	21 July 2017	21 July 2020	15	21 July 2017	CUST-348336	1198318.34	56748.62	Annually	3099.95	AGT-4456	July	Q3	2017	21 July 2018	TR-UNCD988	RSE-TRCD-9856	Lapsed	Bihar	RMC9F7L5	ZMN8K2L1	56748.62	851229.30	3	170245.86	680983.44	-100.00%	-851229.30	21-07-2032	0	1	0
9994	TRS-POL-274989	21 March 2022	21 March 2022	22	21 March 2022	CUST-516693	608369.79	19599.33	Quarterly	2347.60	AGT-4456	March	Q1	2022	21 March 2023	TR-WHCD968	GWB-TRCD-9833	Lapsed	Bihar	RMC9F7L5	ZMN8K2L1	78397.32	1724741.04	0	0.00	1724741.04	NaN	-1724741.04	21-03-2044	0	0	0
9995	TRS-POL-559584	19 July 2024	19 July 2024	12	19 July 2024	CUST-923180	349590.39	37745.08	Monthly	4595.54	AGT-4456	July	Q3	2024	19 July 2025	TR-ENDD989	STP-TRCD-9812	Claimed	Bihar	RMC9F7L5	ZMN8K2L1	452940.96	5435291.52	0	0.00	5435291.52	NaN	-5435291.52	19-07-2036	0	0	1
9996	TRS-POL-841642	12 November 2020	12 November 2020	12	12 November 2020	CUST-741949	296895.39	15641.59	Annually	1729.38	AGT-4456	November	Q4	2020	12 November 2021	TR-ENDD989	STP-TRCD-9812	Claimed	Bihar	RMC9F7L5	ZMN8K2L1	15641.59	187699.08	0	0.00	187699.08	NaN	-187699.08	12-11-2032	0	1	0
9997	TRS-POL-957843	08 August 2016	08 August 2019	22	08 August 2016	CUST-939199	1714215.96	62690.51	Annually	2547.18	AGT-4456	August	Q3	2016	08 August 2017	TR-WHCD968	GWB-TRCD-9833	Lapsed	Bihar	RMC9F7L5	ZMN8K2L1	62690.51	1379191.22	3	188071.53	1191119.69	-100.00%	-1379191.22	08-08-2038	0	0	1
9998	TRS-POL-919446	01 March 2022	01 March 2022	15	01 March 2022	CUST-451502	626672.09	22644.85	Quarterly	2717.31	AGT-4456	March	Q1	2022	01 March 2023	TR-UNCD988	RSE-TRCD-9856	Claimed	Bihar	RMC9F7L5	ZMN8K2L1	90579.40	1358691.00	0	0.00	1358691.00	NaN	-1358691.00	01-03-2037	0	0	1
9999	TRS-POL-180401	26 December 2021	26 December 2021	12	26 December 2021	CUST-703127	1866944.96	28902.43	Monthly	6965.41	AGT-4456	December	Q4	2021	26 December 2022	TR-ENDD989	STP-TRCD-9812	Lapsed	Bihar	RMC9F7L5	ZMN8K2L1	346829.16	4161949.92	0	0.00	4161949.92	NaN	-4161949.92	26-12-2033	0	1	0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts